


* Read in file that contains educational attainment by oblast (for people 10 or older) from 1979 census
import excel using "$data/educ1979_oblast.xlsx", clear firstrow sheet("Sheet1") cellrange(A5:K94)
drop B
save "$datatemp/educ1979_oblast.dta", replace

* Merge the urban/rural women data-file with the education file

use "$datatemp/educ1979_oblast.dta", clear
sort Birthplace_code
merge (Birthplace_code) using "$datatemp/women1544_79cens.dta"
keep if _merge==3
drop _merge Birthplace_80
sort Birthplace_code
save "$datatemp/urb_educ_vars.dta", replace
